Skip to main content

ValuesNOTIN

1. Description​

The ValuesNOTIN Derivation Type is used to ensure forbidden values are not present in specified column.

2. Screen Configuration​

values_notin_image

For the column names provided, it checks if the values of that column does not belong to one of the value provided in values section of required fields.

3. Required Fields​

  • name: Output Field Name.
  • data_type: Output Field Type. Possible values are: "String".
  • dervation
    • derivation_type: The calculation type used to derive this output field, which for concat is "CONCAT".
    • req_fields
      • col_name: Field names from the input metadata.
      • values: Values that should not be present (Comma separated).